namespace CRM.DataAccess.Entities
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;

    [Table("ACCOUNTS")]
    public partial class ACCOUNT
    {
        public long ID { get; set; }

        public bool DELETED { get; set; }

        public long? CREATED_BY { get; set; }

        public DateTime DATE_ENTERED { get; set; }

        public long? MODIFIED_USER_ID { get; set; }

        public DateTime DATE_MODIFIED { get; set; }

        public DateTime? DATE_MODIFIED_UTC { get; set; }

        public long? ASSIGNED_USER_ID { get; set; }

        public long? TEAM_ID { get; set; }

        [StringLength(30)]
        public string ACCOUNT_NUMBER { get; set; }

        [StringLength(150)]
        public string NAME { get; set; }

        [StringLength(25)]
        public string ACCOUNT_TYPE { get; set; }

        public long? PARENT_ID { get; set; }

        [StringLength(25)]
        public string INDUSTRY { get; set; }

        [StringLength(25)]
        public string ANNUAL_REVENUE { get; set; }

        [StringLength(25)]
        public string PHONE_FAX { get; set; }

        [StringLength(150)]
        public string BILLING_ADDRESS_STREET { get; set; }

        [StringLength(100)]
        public string BILLING_ADDRESS_CITY { get; set; }

        [StringLength(100)]
        public string BILLING_ADDRESS_STATE { get; set; }

        [StringLength(20)]
        public string BILLING_ADDRESS_POSTALCODE { get; set; }

        [StringLength(100)]
        public string BILLING_ADDRESS_COUNTRY { get; set; }

        public string DESCRIPTION { get; set; }

        [StringLength(25)]
        public string RATING { get; set; }

        [StringLength(25)]
        public string PHONE_OFFICE { get; set; }

        [StringLength(25)]
        public string PHONE_ALTERNATE { get; set; }

        [StringLength(100)]
        public string EMAIL1 { get; set; }

        [StringLength(100)]
        public string EMAIL2 { get; set; }

        [StringLength(255)]
        public string WEBSITE { get; set; }

        [StringLength(100)]
        public string OWNERSHIP { get; set; }

        [StringLength(10)]
        public string EMPLOYEES { get; set; }

        [StringLength(10)]
        public string SIC_CODE { get; set; }

        [StringLength(10)]
        public string TICKER_SYMBOL { get; set; }

        [StringLength(150)]
        public string SHIPPING_ADDRESS_STREET { get; set; }

        [StringLength(100)]
        public string SHIPPING_ADDRESS_CITY { get; set; }

        [StringLength(100)]
        public string SHIPPING_ADDRESS_STATE { get; set; }

        [StringLength(20)]
        public string SHIPPING_ADDRESS_POSTALCODE { get; set; }

        [StringLength(100)]
        public string SHIPPING_ADDRESS_COUNTRY { get; set; }

        public long? CAMPAIGN_ID { get; set; }

        public long? TEAM_SET_ID { get; set; }
    }
}
